Tabela GPSubscription

Definicja tabeli GPSubscription

Name

GPSubscription

Code

GPSubscription

Comment

 


Lista kolumn tabeli GPSubscription

Name

Code

GPSubscriptionID

GPSubscriptionID

OrgUnitID

OrgUnitID

InsurerID

InsurerID

PatientID

PatientID

PersonnelID

PersonnelID

SchoolID

SchoolID

StartDT

StartDT

StopDT

StopDT

Comments

Comments

Active

Active

IsMilitaryServicePlace

IsMilitaryServicePlace

IsBaseOfPayment

IsBaseOfPayment

IdentificationDocumentNo

IdentificationDocumentNo

FluoridePrevention

FluoridePrevention

Version

Version

ProblemsDesc

ProblemsDesc

ServiceRangeCode

ServiceRangeCode

DistinguishingMark

DistinguishingMark

ServCode

ServCode

InsertDate

InsertDate

InsertingPerson

InsertingPerson

LastModifiedDT

LastModifiedDT

LastModifiedPerson

LastModifiedPerson

ClassNo

ClassNo

CategoryGPID

CategoryGPID

GPSubscriptionTypeID

GPSubscriptionTypeID

IdentificationTypeID

IdentificationTypeID

PupilCategoryID

PupilCategoryID

GPSubscriptionStatusID

GPSubscriptionStatusID


Kolumna GPSubscriptionID tabeli GPSubscription

Definicja kolumny GPSubscriptionID tabeli GPSubscription

Name

GPSubscriptionID

Code

GPSubscriptionID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna OrgUnitID tabeli GPSubscription

Definicja kolumny OrgUnitID tabeli GPSubscription

Name

OrgUnitID

Code

OrgUnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna InsurerID tabeli GPSubscription

Definicja kolumny InsurerID tabeli GPSubscription

Name

InsurerID

Code

InsurerID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PatientID tabeli GPSubscription

Definicja kolumny PatientID tabeli GPSubscription

Name

PatientID

Code

PatientID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PersonnelID tabeli GPSubscription

Definicja kolumny PersonnelID tabeli GPSubscription

Name

PersonnelID

Code

PersonnelID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna SchoolID tabeli GPSubscription

Definicja kolumny SchoolID tabeli GPSubscription

Name

SchoolID

Code

SchoolID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna StartDT tabeli GPSubscription

Definicja kolumny StartDT tabeli GPSubscription

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

Data i godzina rozpoczecia przepustki


Kolumna StopDT tabeli GPSubscription

Definicja kolumny StopDT tabeli GPSubscription

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

Data zakonczenia sesji lub cyklu leczenia


Kolumna Comments tabeli GPSubscription

Definicja kolumny Comments tabeli GPSubscription

Name

Comments

Code

Comments

Data Type

VARCHAR2(1024)

Mandatory

No

Comment

 


Kolumna Active tabeli GPSubscription

Definicja kolumny Active tabeli GPSubscription

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna IsMilitaryServicePlace tabeli GPSubscription

Definicja kolumny IsMilitaryServicePlace tabeli GPSubscription

Name

IsMilitaryServicePlace

Code

IsMilitaryServicePlace

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna IsBaseOfPayment tabeli GPSubscription

Definicja kolumny IsBaseOfPayment tabeli GPSubscription

Name

IsBaseOfPayment

Code

IsBaseOfPayment

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna IdentificationDocumentNo tabeli GPSubscription

Definicja kolumny IdentificationDocumentNo tabeli GPSubscription

Name

IdentificationDocumentNo

Code

IdentificationDocumentNo

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna FluoridePrevention tabeli GPSubscription

Definicja kolumny FluoridePrevention tabeli GPSubscription

Name

FluoridePrevention

Code

FluoridePrevention

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna Version tabeli GPSubscription

Definicja kolumny Version tabeli GPSubscription

Name

Version

Code

Version

Data Type

VARCHAR2(12)

Mandatory

No

Comment

 


Kolumna ProblemsDesc tabeli GPSubscription

Definicja kolumny ProblemsDesc tabeli GPSubscription

Name

ProblemsDesc

Code

ProblemsDesc

Data Type

VARCHAR2(512)

Mandatory

No

Comment

 


Kolumna ServiceRangeCode tabeli GPSubscription

Definicja kolumny ServiceRangeCode tabeli GPSubscription

Name

ServiceRangeCode

Code

ServiceRangeCode

Data Type

VARCHAR2(14)

Mandatory

No

Comment

Ustalony przez platnika kod zakresu swiadczen ze slownika platnika. (Zakres swiadczen- dawniej nazywany 'produktem kontraktowym' ustalany przez platnika na podstawie przekazanych danych deklaracji (tzw.czynników stawki))


Kolumna DistinguishingMark tabeli GPSubscription

Definicja kolumny DistinguishingMark tabeli GPSubscription

Name

DistinguishingMark

Code

DistinguishingMark

Data Type

NUMBER(10)

Mandatory

No

Comment

Wyróznik (wariant) zakresu swiadczen. (Wystepuje tylko wtedy, gdy zakres swiadczen posiada zdefiniowane wyrózniki)


Kolumna ServCode tabeli GPSubscription

Definicja kolumny ServCode tabeli GPSubscription

Name

ServCode

Code

ServCode

Data Type

VARCHAR2(16)

Mandatory

No

Comment

Kod swiadczenia z katalogu platnika. (swiadczenie z katalogu platnika dawniej bylo nazywane 'produktem jednostkowym')


Kolumna InsertDate tabeli GPSubscription

Definicja kolumny InsertDate tabeli GPSubscription

Name

InsertDate

Code

InsertDate

Data Type

DATE

Mandatory

No

Comment

PL: Data wstawienia rekordu
EN: Insert date of record
DE: Das Date der Ansatzstelle fur den Rekord


Kolumna InsertingPerson tabeli GPSubscription

Definicja kolumny InsertingPerson tabeli GPSubscription

Name

InsertingPerson

Code

InsertingPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

PL: Osoba wstawiajaca rekord
EN: Person inserting record


Kolumna LastModifiedDT tabeli GPSubscription

Definicja kolumny LastModifiedDT tabeli GPSubscription

Name

LastModifiedDT

Code

LastModifiedDT

Data Type

DATE

Mandatory

No

Comment

Data ostatniej modyfikacji


Kolumna LastModifiedPerson tabeli GPSubscription

Definicja kolumny LastModifiedPerson tabeli GPSubscription

Name

LastModifiedPerson

Code

LastModifiedPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ClassNo tabeli GPSubscription

Definicja kolumny ClassNo tabeli GPSubscription

Name

ClassNo

Code

ClassNo

Data Type

VARCHAR2(10)

Mandatory

No

Comment

 


Kolumna CategoryGPID tabeli GPSubscription

Definicja kolumny CategoryGPID tabeli GPSubscription

Name

CategoryGPID

Code

CategoryGPID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna GPSubscriptionTypeID tabeli GPSubscription

Definicja kolumny GPSubscriptionTypeID tabeli GPSubscription

Name

GPSubscriptionTypeID

Code

GPSubscriptionTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna IdentificationTypeID tabeli GPSubscription

Definicja kolumny IdentificationTypeID tabeli GPSubscription

Name

IdentificationTypeID

Code

IdentificationTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PupilCategoryID tabeli GPSubscription

Definicja kolumny PupilCategoryID tabeli GPSubscription

Name

PupilCategoryID

Code

PupilCategoryID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna GPSubscriptionStatusID tabeli GPSubscription

Definicja kolumny GPSubscriptionStatusID tabeli GPSubscription

Name

GPSubscriptionStatusID

Code

GPSubscriptionStatusID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Lista kluczy tabeli GPSubscription

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli GPSubscription

Definicja klucza Identifier_1 tabeli GPSubscription

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment